<?php include "conn.php";
$shop_res= "SELECT * FROM `biz_zone` where city_id = 1 and parent_id=0 order by ordnum" ; 
$shop_res = mysqli_query($conn, $shop_res);
while($shopres = mysqli_fetch_array($shop_res))
{$data[] = $shopres;}
$shop_res_all= "SELECT * FROM `biz_zone` where city_id = 1 order by ordnum" ;
$shop_res_all = mysqli_query($conn, $shop_res_all);
while($shopres_all = mysqli_fetch_array($shop_res_all))
{$data_all[] = $shopres_all;}


$title ='速订客,美食订餐网'; 
?>
<?php include "header.php";?>
<body>
<?php include "body_top.php";?>
      <table class="restaurant-list-table">
        <? foreach($data as $row)
{?>
        <tr class="open">
          <td ><div class="breadcrumb"><strong> <a href="select.php?zone_a=<?= $row['pinyin']; ?>&zone_id=<?=$row['zone_id'];?>&parent_id=<?=$row['parent_id'];?>">
              <?= $row['name'];?>
              </a>&nbsp;</strong></div></td>
        </tr>
        <tr class="open">
          <td ><div class="breadcrumb">
              <? foreach($data_all as $row_all){
	
if($row_all['parent_id']==$row['zone_id'])
{ 
?>
              <a href="select.php?zone_a=<?= $row_all['pinyin']; ?>&zone_id=<?=$row_all['zone_id'];?>&parent_id=<?=$row_all['parent_id'];?>">
              <?= $row_all['name'];?>
              </a>&nbsp;
              <? }
}?>
            </div>
            <br \></td>
        </tr>
        <? }?>
      </table>
      <?php include "footer.php";?>